<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Index</title>
<link type="text/css" href="../../skin/page.css" rel="stylesheet">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<!--================= start Navigation Path ==================-->
<table summary="navigation path" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td nowrap="nowrap" valign="middle" bgcolor="#CFDCED" height="20"><img height="1" width="5" alt="" src="../../skin/images/spacer.gif" class="spacer"><!--===== breadcrumb trail (javascript-generated) ====--><font size="2" face="Arial, Helvetica, Sans-serif"><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script></font></td>
</tr>
<tr>
<td bgcolor="#4C6C8F" height="2"><img height="2" width="2" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
<!--================= end Navigation Path ==================-->
<!--================= start Banner ==================-->
<table summary="header with logos" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<!--================= start Group Logo ==================-->
<td bgcolor="#294563"><a href="http://incubator.apache.org"><img border="0" class="logoImage" alt="" src="../../resources/images/apache-incubator.png" title="Derby is a zero admin java based embedded database."></a></td>
<!--================= end Group Logo ==================-->
<!--================= start Project Logo ==================--><td width="100%" align="center" bgcolor="#294563"><a href="http://incubator.apache.org/derby/"><img border="0" class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin java based embedded database."></a></td>
<!--================= end Project Logo ==================-->
<!--================= start Search ==================--><td valign="top" rowspan="2" bgcolor="#294563">
<form target="_blank" action="http://www.google.com/search" method="get">
<table summary="search" border="0" cellspacing="0" cellpadding="0" bgcolor="#4C6C8F">
<tr>
<td colspan="3"><img height="10" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap"><input value="incubator.apache.org" name="sitesearch" type="hidden"><input size="15" name="q" id="query" type="text"><img height="1" width="5" alt="" src="../../skin/images/spacer.gif" class="spacer"><input name="Search" value="Search" type="submit">
<br>
<font face="Arial, Helvetica, Sans-serif" size="2" color="white">
                      the Derby site
                      
                      
                    </font></td><td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td><img alt="" border="0" height="10" width="9" src="../../skin/images/search-left.gif"></td><td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td><img alt="" border="0" height="10" width="9" src="../../skin/images/search-right.gif"></td>
</tr>
</table>
</form>
</td>
<!--================= start Search ==================--><td bgcolor="#294563"><img height="10" width="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td valign="bottom" bgcolor="#294563" colspan="2">
<!--================= start Tabs ==================-->
<div class="tab">
<table summary="tab bar" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="non selected tab" style="height: 1.6em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-left.gif"></td><td valign="middle" bgcolor="#B2C4E0"><a class="base-not-selected" href="../../index.html">Home</a></td><td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-right.gif"></td>
</tr>
<tr>
<td colspan="3" height="1"></td>
</tr>
</table>
</td><td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="selected tab" style="height: 1.8em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#4C6C8F"><img height="5" width="5" alt="" src="../../skin/images/tabSel-left.gif"></td><td valign="middle" bgcolor="#4C6C8F"><font color="#ffffff" size="2" face="Arial, Helvetica, Sans-serif"><b><a class="base-selected" href="../../manuals/index.html">Manuals</a></b></font></td><td valign="top" width="5" bgcolor="#4C6C8F"><img height="5" width="5" alt="" src="../../skin/images/tabSel-right.gif"></td>
</tr>
</table>
</td><td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="non selected tab" style="height: 1.6em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-left.gif"></td><td valign="middle" bgcolor="#B2C4E0"><a class="base-not-selected" href="../../papers/index.html">Papers</a></td><td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-right.gif"></td>
</tr>
<tr>
<td colspan="3" height="1"></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<!--================= end Tabs ==================-->
</td><td bgcolor="#294563"><img alt="" width="1" height="1" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td bgcolor="#4C6C8F" colspan="4"><img width="1" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
<!--================= end Banner ==================-->
<!--================= start Menu, NavBar, Content ==================-->
<table summary="page content" bgcolor="#ffffff" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<table summary="menu" border="0" cellspacing="0" cellpadding="0">
<tr>
<!--================= start left top NavBar ==================-->
<td rowspan="3" valign="top">
<table summary="blue line" border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td bgcolor="#CFDCED"><font color="#4C6C8F" size="4" face="Arial, Helvetica, Sans-serif">&nbsp;</font></td>
</tr>
<tr>
<td bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
</td>
<!--================= end left top NavBar ==================--><td bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td valign="bottom" bgcolor="#4C6C8F"><img width="10" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap" valign="top" bgcolor="#4C6C8F">
<!--================= start Menu items ==================-->
<div class="menu">
<ul>
<li>
<font color="#CFDCED">Manuals</font>
<ul>
     
<li>
<a href="../../manuals/index.html">About</a>
</li>
     
<li>
<font color="#CFDCED">Getting Started</font>
<ul>
         
<li>
<a href="../../manuals/getstart/gspr02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/getstart/gspr40.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>
     
<li>
<font color="#CFDCED">Reference Manual</font>
<ul>
         
<li>
<a href="../../manuals/reference/sqlj02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<span class="sel"><font color="#ffcc00">Index</font></span>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>

     
<li>
<font color="#CFDCED">Developer's Guide</font>
<ul>
         
<li>
<a href="../../manuals/develop/develop02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/develop/develop157.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>
     
<li>
<font color="#CFDCED">Tuning Derby</font>
<ul>
         
<li>
<a href="../../manuals/tuning/perf02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/tuning/perf121.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>

     
<li>
<font color="#CFDCED">Server &amp; Admin Guide</font>
<ul>
         
<li>
<a href="../../manuals/admin/hubprnt02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/admin/hubprnt65.html" title="Index">Index</a>
</li>
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
        
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
    
</ul>
</li>

    
<li>
<font color="#CFDCED">Tools &amp; Utility Guide</font>
<ul>
         
<li>
<a href="../../manuals/tools/tools02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/tools/tools113.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
    
</ul>
</li>
  
</ul>
</li>
</ul>
</div>
<!--================= end Menu items ==================-->
</td><td valign="bottom" bgcolor="#4C6C8F"><img width="10" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td valign="bottom" align="left" colspan="2" rowspan="2" bgcolor="#4C6C8F"><img height="10" width="10" border="0" alt="" src="../../skin/images/menu-left.gif"></td><td bgcolor="#4C6C8F"><img height="10" width="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td valign="bottom" align="right" colspan="2" rowspan="2" bgcolor="#4C6C8F"><img height="10" width="10" border="0" alt="" src="../../skin/images/menu-right.gif"></td>
</tr>
<tr>
<td height="1" bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
</td><td valign="top" width="100%">
<table summary="content" width="100%" border="0" cellpadding="0" cellspacing="0">
<!--================= start middle NavBar ==================-->
<tr>
<td colspan="4" bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td align="left" width="10" bgcolor="#CFDCED"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td align="left" width="50%" bgcolor="#CFDCED"><font color="#4C6C8F" size="3" face="Arial, Helvetica, Sans-serif">
                &nbsp;
                
                </font><img width="10" height="8" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td align="right" width="50%" bgcolor="#CFDCED"><font color="#4C6C8F" size="3" face="Arial, Helvetica, Sans-serif">
                &nbsp;
                
                </font><img width="10" height="8" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td width="10" bgcolor="#CFDCED"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td colspan="4" bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<!--================= end middle NavBar ==================-->
<!--================= start Content==================-->
<tr>
<td align="left" width="10"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td colspan="2" align="left" width="100%">
<div class="content">
<table class="title" summary="">
<tr>
<td valign="middle">
<h1>Index</h1>
</td>
</tr>
</table>
<ul class="minitoc">
<li>
<a href="#Index">Index</a>
</li>
</ul>
<a name="N1003A"></a><a name="Index"></a>
<h3>Index</h3>
<div style="margin-left: 0 ; border: 2px">
<strong><a href="#IDX0_00">Special characters</a></strong>
<ul>
<li>? <a href="sqlj08.html#IDX731">(731)</a>
</li>
<li>+ -, *, /, unary + and - expressions <a href="sqlj146.html#IDX1025">(1025)</a>
</li>
<li>? (dynamic parameter) <ul>
<li>in prepared statements <a href="sqlj149.html#IDX1053">(1053)</a>
</li>
<li>used in conditional expression <a href="sqlj149.html#IDX1054">(1054)</a>
</li>
</ul>
</li>
<li>% as wildcard in SQL <a href="sqlj08.html#IDX727">(727)</a>
</li>
<li>* as wildcard in SQL SELECT <a href="sqlj08.html#IDX726">(726)</a>, <a href="sqlj48.html#IDX884">(884)</a>
</li>
<li>_ as wildcard within SQL <a href="sqlj08.html#IDX728">(728)</a>
</li>
<li>{call (JDBC escape syntax) <a href="sqlj231.html#IDX1156">(1156)</a>
</li>
<li>{d (JDBC escape syntax) <a href="sqlj232.html#IDX1158">(1158)</a>
</li>
<li>{oj (JDBC escape syntax) <a href="sqlj235.html#IDX1170">(1170)</a>
</li>
<li>{t (JDBC escape syntax) <a href="sqlj236.html#IDX1173">(1173)</a>
</li>
<li>{ts (JDBC escape syntax) <a href="sqlj237.html#IDX1176">(1176)</a>
</li>
</ul>
<strong><a href="#IDX0_41">A</a></strong>
<ul>
<li>abs (JDBC scalar function) <a href="sqlj234.html#IDX1165">(1165)</a>
</li>
<li>ABS or ABSVAL (function) <a href="sqlj59.html#IDX900">(900)</a>
</li>
<li>Adding Columns <a href="sqlj26.html#IDX764">(764)</a>
</li>
<li>Adding Constraints <a href="sqlj26.html#IDX765">(765)</a>
</li>
<li>Aggregates <a href="sqlj58.html#IDX897">(897)</a> 
<ul>
<li>and data types <a href="sqlj58.html#IDX898">(898)</a>
</li>
<li>definition <a href="sqlj58.html#IDX896">(896)</a>
</li>
<li>requirements for <a href="sqlj58.html#IDX899">(899)</a>
</li>
</ul>
</li>
<li>ALTER TABLE statement <a href="sqlj26.html#IDX753">(753)</a>
</li>
<li>AND boolean operator <a href="sqlj148.html#IDX1038">(1038)</a>
</li>
<li>ASC <ul>
<li>implied in ORDER BY clause <a href="sqlj44.html#IDX874">(874)</a>
</li>
</ul>
</li>
<li>Attributes to database connection URL <a href="sqlj238.html#IDX1178">(1178)</a>, <a href="sqlj253.html#IDX1205">(1205)</a>
</li>
<li>AuthorizationIdentifierName identifier <a href="sqlj23.html#IDX750">(750)</a>
</li>
<li>autogenerated keys <a href="sqlj229.html#IDX1152">(1152)</a>
</li>
<li>AVG aggregate function <a href="sqlj60.html#IDX901">(901)</a>
</li>
</ul>
<strong><a href="#IDX0_42">B</a></strong>
<ul>
<li>Backing indexes <ul>
<li>created automatically to enforce primary key, unique, and foreign key constraints <a href="sqlj27.html#IDX780">(780)</a>, <a href="sqlj32.html#IDX843">(843)</a>
</li>
<li>specifying storage properties for <a href="sqlj32.html#IDX846">(846)</a>
</li>
</ul>
</li>
<li>Batch processing (JDBC) <a href="sqlj212.html#IDX1140">(1140)</a>, <a href="sqlj213.html#IDX1141">(1141)</a>, <a href="sqlj214.html#IDX1142">(1142)</a>
</li>
<li>BETWEEN boolean operator <a href="sqlj148.html#IDX1046">(1046)</a>
</li>
<li>BIGINT data type <a href="sqlj126.html#IDX994">(994)</a>
</li>
<li>BIGINT function <a href="sqlj61.html#IDX903">(903)</a>
</li>
<li>BLOB data type <a href="sqlj127.html#IDX995">(995)</a>, <a href="sqlj208.html#IDX1135">(1135)</a>
</li>
<li>Boolean expression <a href="sqlj148.html#IDX1036">(1036)</a>
</li>
<li>Boolean operators <ul>
<li>part of WHERE clause <a href="sqlj148.html#IDX1037">(1037)</a>
</li>
</ul>
</li>
<li>bootPassword=key (database connection URL attribute) <a href="sqlj239.html#IDX1179">(1179)</a>
</li>
<li>Byte strings <ul>
<li>variable-length <a href="sqlj145.html#IDX1014">(1014)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_43">C</a></strong>
<ul>
<li>call (JDBC escape keyword) <a href="sqlj231.html#IDX1155">(1155)</a>
</li>
<li>CALL (PROCEDURE) <a href="sqlj31.html#IDX822">(822)</a>
</li>
<li>CASE expression <a href="sqlj66.html#IDX911">(911)</a>
</li>
<li>Case sensitivity of keywords and identifiers <a href="sqlj08.html#IDX723">(723)</a>
</li>
<li>CAST expression <a href="sqlj146.html#IDX1020">(1020)</a>
</li>
<li>CAST function <a href="sqlj62.html#IDX904">(904)</a>
</li>
<li>CHAR data type <a href="sqlj128.html#IDX996">(996)</a>
</li>
<li>CHAR FOR BIT DATA type <a href="sqlj129.html#IDX997">(997)</a>
</li>
<li>CHAR function <a href="sqlj63.html#IDX907">(907)</a>
</li>
<li>Character expressions <a href="sqlj146.html#IDX1027">(1027)</a>
</li>
<li>Check constraints <a href="sqlj32.html#IDX849">(849)</a>
</li>
<li>Class path <ul>
<li>accessing read-only databases from <a href="sqlj178.html#IDX1087">(1087)</a>
</li>
</ul>
</li>
<li>CLOB data type <a href="sqlj130.html#IDX998">(998)</a>, <a href="sqlj208.html#IDX1136">(1136)</a>
</li>
<li>Column defaults <a href="sqlj27.html#IDX788">(788)</a>
</li>
<li>Column-level constraints <a href="sqlj32.html#IDX826">(826)</a> 
<ul>
<li>used in CREATE TABLE statement <a href="sqlj32.html#IDX830">(830)</a>
</li>
</ul>
</li>
<li>column-Name identifier <a href="sqlj17.html#IDX744">(744)</a>
</li>
<li>Column reference expression <a href="sqlj146.html#IDX1016">(1016)</a>
</li>
<li>Column widths <ul>
<li>increasing <a href="sqlj26.html#IDX771">(771)</a>
</li>
</ul>
</li>
<li>Columns <ul>
<li>adding <a href="sqlj26.html#IDX757">(757)</a>
</li>
<li>modifying <a href="sqlj26.html#IDX767">(767)</a>
</li>
</ul>
</li>
<li>org.apache.derby.authentication.UserAuthenticator <a href="sqlj265.html#IDX1237">(1237)</a>
</li>
<li>org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource <a href="sqlj264.html#IDX1235">(1235)</a>
</li>
<li>org.apache.derby.jdbc.EmbeddedDataSource <a href="sqlj264.html#IDX1234">(1234)</a>
</li>
<li>org.apache.derby.jdbc.EmbeddedDriver <a href="sqlj263.html#IDX1233">(1233)</a>
</li>
<li>org.apache.derby.jdbc.EmbeddedXADataSource <a href="sqlj264.html#IDX1236">(1236)</a>
</li>
<li>org.apache.derby.tools.sysinfo <a href="sqlj261.html#IDX1232">(1232)</a>
</li>
<li>Comment delimiters within SQL <a href="sqlj08.html#IDX730">(730)</a>
</li>
<li>Comparison boolean operators <a href="sqlj148.html#IDX1041">(1041)</a>
</li>
<li>Compressing tables <a href="sqlj26.html#IDX754">(754)</a>
</li>
<li>Compressing Tables <a href="sqlj110.html#IDX957">(957)</a>
</li>
<li>concat (JDBC scalar function) <a href="sqlj234.html#IDX1163">(1163)</a>
</li>
<li>Concatenation function <a href="sqlj65.html#IDX909">(909)</a> 
<ul>
<li>as expression <a href="sqlj146.html#IDX1029">(1029)</a>
</li>
</ul>
</li>
<li>Conditional expression <a href="sqlj146.html#IDX1023">(1023)</a>
</li>
<li>Connecting to a database (using databaseName attribute) <a href="sqlj241.html#IDX1184">(1184)</a>
</li>
<li>Connection pooling <a href="sqlj255.html#IDX1210">(1210)</a>, <a href="sqlj259.html#IDX1227">(1227)</a>
</li>
<li>Connections <ul>
<li>garbage collection of <a href="sqlj182.html#IDX1092">(1092)</a>
</li>
<li>session-severity exceptions closing <a href="sqlj182.html#IDX1093">(1093)</a>
</li>
<li>system-severity exceptions closing <a href="sqlj182.html#IDX1094">(1094)</a>
</li>
</ul>
</li>
<li>Constant expression <a href="sqlj146.html#IDX1017">(1017)</a>
</li>
<li>Constraint clause <ul>
<li>referential actions in <a href="sqlj32.html#IDX851">(851)</a>
</li>
</ul>
</li>
<li>CONSTRAINT clause <a href="sqlj32.html#IDX824">(824)</a>
</li>
<li>constraint-Name identifier <a href="sqlj20.html#IDX747">(747)</a>
</li>
<li>Constraints <a href="sqlj32.html#IDX825">(825)</a> 
<ul>
<li>adding <a href="sqlj26.html#IDX758">(758)</a>
</li>
<li>column-level <a href="sqlj32.html#IDX827">(827)</a>, <a href="sqlj32.html#IDX831">(831)</a>
</li>
<li>compressing <a href="sqlj26.html#IDX760">(760)</a>
</li>
<li>differences between column-level and table-level <a href="sqlj32.html#IDX838">(838)</a>
</li>
<li>dropping <a href="sqlj26.html#IDX759">(759)</a>
</li>
<li>table-level <a href="sqlj32.html#IDX829">(829)</a>, <a href="sqlj32.html#IDX835">(835)</a>
</li>
</ul>
</li>
<li>Conversions <ul>
<li>of SQL-92 data types using CAST <a href="sqlj62.html#IDX905">(905)</a>
</li>
<li>using CAST function (explicit) <a href="sqlj62.html#IDX906">(906)</a>
</li>
</ul>
</li>
<li>correlation-Name identifier <a href="sqlj16.html#IDX743">(743)</a>
</li>
<li>COUNT(*) aggregate function <a href="sqlj68.html#IDX914">(914)</a>
</li>
<li>COUNT aggregate function <a href="sqlj67.html#IDX912">(912)</a>
</li>
<li>CREATE FUNCTION statement <a href="sqlj27.html#IDX774">(774)</a>
</li>
<li>CREATE INDEX statement <a href="sqlj27.html#IDX776">(776)</a>
</li>
<li>CREATE PROCEDURE statement <a href="sqlj27.html#IDX782">(782)</a>
</li>
<li>CREATE SCHEMA statement <a href="sqlj27.html#IDX784">(784)</a>
</li>
<li>CREATE TABLE statement <a href="sqlj27.html#IDX786">(786)</a>
</li>
<li>CREATE TRIGGER statement <a href="sqlj27.html#IDX791">(791)</a>
</li>
<li>create=true (database connection URL attribute) <a href="sqlj240.html#IDX1182">(1182)</a>
</li>
<li>CREATE VIEW statement <a href="sqlj27.html#IDX801">(801)</a>
</li>
<li>createFrom=Path (database connection URL attribute) <a href="sqlj249.html#IDX1201">(1201)</a>
</li>
<li>CURRENT DATE function <a href="sqlj69.html#IDX915">(915)</a>
</li>
<li>CURRENT_DATE function <a href="sqlj70.html#IDX916">(916)</a> 
<ul>
<li>as expression <a href="sqlj146.html#IDX1031">(1031)</a>
</li>
</ul>
</li>
<li>CURRENT ISOLATION function <a href="sqlj71.html#IDX917">(917)</a>
</li>
<li>CURRENT TIME function <a href="sqlj73.html#IDX920">(920)</a>
</li>
<li>CURRENT_TIME function <a href="sqlj74.html#IDX921">(921)</a> 
<ul>
<li>as expression <a href="sqlj146.html#IDX1032">(1032)</a>
</li>
</ul>
</li>
<li>CURRENT TIMESTAMP function <a href="sqlj75.html#IDX922">(922)</a>
</li>
<li>CURRENT_TIMESTAMP function <a href="sqlj76.html#IDX923">(923)</a> 
<ul>
<li>expression <a href="sqlj146.html#IDX1033">(1033)</a>
</li>
</ul>
</li>
<li>CURRENT_USER function <a href="sqlj77.html#IDX924">(924)</a>
</li>
<li>cursor-Name identifier <a href="sqlj21.html#IDX748">(748)</a>
</li>
<li>Cursors <a href="sqlj35.html#IDX857">(857)</a>, <a href="sqlj35.html#IDX858">(858)</a> 
<ul>
<li>pre-fetching affecting <a href="sqlj201.html#IDX1116">(1116)</a>
</li>
<li>scrolling insensitive <a href="sqlj210.html#IDX1139">(1139)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_44">D</a></strong>
<ul>
<li>d (JDBC escape keyword) <a href="sqlj232.html#IDX1157">(1157)</a>
</li>
<li>Data encryption <ul>
<li>algorithms <a href="sqlj244.html#IDX1192">(1192)</a>
</li>
<li>providers <a href="sqlj243.html#IDX1189">(1189)</a>
</li>
</ul>
</li>
<li>Data sources <a href="sqlj259.html#IDX1224">(1224)</a> 
<ul>
<li>creating a database for <a href="sqlj259.html#IDX1230">(1230)</a>
</li>
<li>shutting down a database for <a href="sqlj259.html#IDX1231">(1231)</a>
</li>
</ul>
</li>
<li>Data types <ul>
<li>modifying <a href="sqlj26.html#IDX763">(763)</a>, <a href="sqlj26.html#IDX770">(770)</a>
</li>
</ul>
</li>
<li>Database connection URL <a href="sqlj177.html#IDX1084">(1084)</a> 
<ul>
<li>attributes <a href="sqlj180.html#IDX1088">(1088)</a>
</li>
<li>settable through Properties in connection call <a href="sqlj180.html#IDX1089">(1089)</a>
</li>
<li>syntax in embedded mode <a href="sqlj178.html#IDX1085">(1085)</a>
</li>
</ul>
</li>
<li>Database Manager limitations <a href="sqlj272.html#IDX1251">(1251)</a>
</li>
<li>DatabaseMetaData.getProcedureColumns <a href="sqlj189.html#IDX1100">(1100)</a>
</li>
<li>databaseName=nameOfDatabase (database connection URL attribute) <a href="sqlj241.html#IDX1183">(1183)</a>
</li>
<li>Databases <ul>
<li>encrypting <a href="sqlj239.html#IDX1181">(1181)</a>, <a href="sqlj242.html#IDX1187">(1187)</a>
</li>
<li>territory <a href="sqlj245.html#IDX1195">(1195)</a>
</li>
</ul>
</li>
<li>dataEncryption=true (database connection URL attribute) <a href="sqlj242.html#IDX1185">(1185)</a>
</li>
<li>DATE data type <a href="sqlj131.html#IDX999">(999)</a>
</li>
<li>Date formats <ul>
<li>JDBC escape syntax for <a href="sqlj232.html#IDX1159">(1159)</a>
</li>
</ul>
</li>
<li>DATE function <a href="sqlj78.html#IDX925">(925)</a>
</li>
<li>DATE limitations <a href="sqlj271.html#IDX1247">(1247)</a>
</li>
<li>Date/time expressions <a href="sqlj146.html#IDX1030">(1030)</a>
</li>
<li>DAY function <a href="sqlj79.html#IDX926">(926)</a>
</li>
<li>DECIMAL data type <a href="sqlj132.html#IDX1000">(1000)</a>
</li>
<li>DECLARE GLOBAL TEMPORARY TABLE statement <a href="sqlj33.html#IDX852">(852)</a>
</li>
<li>Defaults <a href="sqlj27.html#IDX787">(787)</a> 
<ul>
<li>adding <a href="sqlj26.html#IDX761">(761)</a>, <a href="sqlj26.html#IDX768">(768)</a>
</li>
<li>dropping <a href="sqlj26.html#IDX762">(762)</a>, <a href="sqlj26.html#IDX769">(769)</a>
</li>
<li>setting <a href="sqlj26.html#IDX772">(772)</a>
</li>
</ul>
</li>
<li>DELETE statement <a href="sqlj34.html#IDX854">(854)</a>
</li>
<li>delimited identifiers <ul>
<li>definition <a href="sqlj10.html#IDX738">(738)</a>
</li>
</ul>
</li>
<li>Dependencies <ul>
<li>internal tracking of <a href="sqlj25.html#IDX751">(751)</a>
</li>
</ul>
</li>
<li>DESC <ul>
<li>optional element of ORDER BY clause <a href="sqlj44.html#IDX875">(875)</a>
</li>
</ul>
</li>
<li>Descending indexes <a href="sqlj27.html#IDX777">(777)</a>
</li>
<li>Dictionary objects <ul>
<li>definition <a href="sqlj09.html#IDX734">(734)</a>
</li>
</ul>
</li>
<li>DISTINCT <ul>
<li>qualifier in AVG function <a href="sqlj60.html#IDX902">(902)</a>
</li>
<li>qualifier in COUNT aggregate function <a href="sqlj67.html#IDX913">(913)</a>
</li>
</ul>
</li>
<li>DISTINCT clause <ul>
<li>part of SelectExpression <a href="sqlj48.html#IDX883">(883)</a>
</li>
</ul>
</li>
<li>Distributed transaction management <a href="sqlj255.html#IDX1214">(1214)</a>
</li>
<li>DOUBLE data type <a href="sqlj133.html#IDX1001">(1001)</a>
</li>
<li>DOUBLE function <a href="sqlj80.html#IDX927">(927)</a>
</li>
<li>DOUBLE PRECISION data type <a href="sqlj134.html#IDX1002">(1002)</a>
</li>
<li>DROP FUNCTION statement <a href="sqlj28.html#IDX803">(803)</a>
</li>
<li>DROP INDEX statement <a href="sqlj28.html#IDX805">(805)</a>
</li>
<li>DROP PROCEDURE statement <a href="sqlj28.html#IDX806">(806)</a>
</li>
<li>DROP SCHEMA statement <a href="sqlj28.html#IDX808">(808)</a>
</li>
<li>DROP TABLE statement <a href="sqlj28.html#IDX810">(810)</a>
</li>
<li>DROP TRIGGER statement <a href="sqlj28.html#IDX812">(812)</a>
</li>
<li>DROP VIEW statement <a href="sqlj28.html#IDX814">(814)</a>
</li>
<li>Dropping Constraints <a href="sqlj26.html#IDX766">(766)</a>
</li>
<li>Dynamic parameter expression <a href="sqlj146.html#IDX1019">(1019)</a>
</li>
<li>Dynamic parameters <a href="sqlj149.html#IDX1050">(1050)</a>
</li>
</ul>
<strong><a href="#IDX0_45">E</a></strong>
<ul>
<li>Encrypting databases <a href="sqlj239.html#IDX1180">(1180)</a>, <a href="sqlj242.html#IDX1186">(1186)</a>
</li>
<li>Encryption <ul>
<li>algorithms <a href="sqlj244.html#IDX1193">(1193)</a>
</li>
<li>providers <a href="sqlj243.html#IDX1190">(1190)</a>
</li>
</ul>
</li>
<li>encryptionAlgorithm=algorithm (database connection URL attribute) <a href="sqlj244.html#IDX1191">(1191)</a>
</li>
<li>encryptionProvider=providerName (database connection URL attribute) <a href="sqlj243.html#IDX1188">(1188)</a>
</li>
<li>escape (JDBC escape keyword) <a href="sqlj233.html#IDX1160">(1160)</a>
</li>
<li>Escape character <ul>
<li>for single-quotation mark <a href="sqlj08.html#IDX722">(722)</a>
</li>
</ul>
</li>
<li>Escape character for LIKE clauses <a href="sqlj233.html#IDX1161">(1161)</a>
</li>
<li>Escape syntax (JDBC) <a href="sqlj230.html#IDX1154">(1154)</a>
</li>
<li>EXISTS boolean operator <a href="sqlj148.html#IDX1048">(1048)</a>
</li>
<li>Export <ul>
<li>SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure <a href="sqlj119.html#IDX978">(978)</a>
</li>
<li>SYSCS_UTIL.SYSCS_EXPORT_TABLE system procedure <a href="sqlj118.html#IDX975">(975)</a>
</li>
</ul>
</li>
<li>Expression subquery <a href="sqlj47.html#IDX881">(881)</a>
</li>
<li>Expressions <ul>
<li>hierarchy of <a href="sqlj147.html#IDX1034">(1034)</a>
</li>
<li>in SQL language <a href="sqlj146.html#IDX1015">(1015)</a>
</li>
<li>precedence of <a href="sqlj147.html#IDX1035">(1035)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_46">F</a></strong>
<ul>
<li>FLOAT data type <ul>
<li>as alias for REAL or DOUBLE PRECISION <a href="sqlj135.html#IDX1003">(1003)</a>
</li>
<li>java.sql type converted to DOUBLE PRECISION when retrieved <a href="sqlj207.html#IDX1129">(1129)</a>
</li>
</ul>
</li>
<li>fn (JDBC escape keyword) <a href="sqlj234.html#IDX1162">(1162)</a>
</li>
<li>FOR UPDATE clause <a href="sqlj35.html#IDX856">(856)</a>
</li>
<li>Foreign keys <a href="sqlj32.html#IDX841">(841)</a>
</li>
<li>FROM clause <a href="sqlj36.html#IDX860">(860)</a>
</li>
<li>FUNCTION <ul>
<li>Create <a href="sqlj27.html#IDX775">(775)</a>
</li>
</ul>
</li>
<li>Functions, built-in <a href="sqlj56.html#IDX894">(894)</a>
</li>
</ul>
<strong><a href="#IDX0_47">G</a></strong>
<ul>
<li>getAsciiStream <a href="sqlj202.html#IDX1119">(1119)</a>
</li>
<li>getBinaryStream <a href="sqlj202.html#IDX1121">(1121)</a>
</li>
<li>getUnicodeStream <a href="sqlj202.html#IDX1120">(1120)</a>
</li>
<li>getXXXStream requests <a href="sqlj202.html#IDX1117">(1117)</a>
</li>
<li>GROUP BY clause <a href="sqlj37.html#IDX861">(861)</a>
</li>
</ul>
<strong><a href="#IDX0_48">H</a></strong>
<ul>
<li>HAVING clause <a href="sqlj38.html#IDX862">(862)</a>
</li>
<li>HOUR function <a href="sqlj81.html#IDX928">(928)</a>
</li>
</ul>
<strong><a href="#IDX0_49">I</a></strong>
<ul>
<li>Identifier length limitations <a href="sqlj268.html#IDX1241">(1241)</a>
</li>
<li>Identifiers <ul>
<li>definition <a href="sqlj09.html#IDX733">(733)</a>
</li>
</ul>
</li>
<li>Identity Column Attributes <a href="sqlj27.html#IDX789">(789)</a>
</li>
<li>Identity columns <ul>
<li>and triggers <a href="sqlj27.html#IDX790">(790)</a>
</li>
</ul>
</li>
<li>Import <ul>
<li>SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure <a href="sqlj121.html#IDX984">(984)</a>
</li>
<li>SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure <a href="sqlj120.html#IDX981">(981)</a>
</li>
</ul>
</li>
<li>IN (? or dynamic) parameters <a href="sqlj149.html#IDX1051">(1051)</a>
</li>
<li>IN boolean operator <a href="sqlj148.html#IDX1047">(1047)</a>
</li>
<li>In-place updates <a href="sqlj35.html#IDX859">(859)</a>
</li>
<li>index-Name identifier <a href="sqlj19.html#IDX746">(746)</a>
</li>
<li>Indexes <ul>
<li>automatic creation of for primary key, unique, and foreign key constraints <a href="sqlj27.html#IDX781">(781)</a>, <a href="sqlj32.html#IDX844">(844)</a>
</li>
<li>created in descending order <a href="sqlj27.html#IDX778">(778)</a>
</li>
<li>specifying page size for <a href="sqlj27.html#IDX779">(779)</a>
</li>
</ul>
</li>
<li>INNER JOIN expression <a href="sqlj39.html#IDX863">(863)</a>
</li>
<li>INSERT statement <a href="sqlj40.html#IDX865">(865)</a>
</li>
<li>INTEGER data type <a href="sqlj136.html#IDX1004">(1004)</a>
</li>
<li>INTEGER function <a href="sqlj83.html#IDX929">(929)</a>
</li>
<li>Internationalization features <ul>
<li>territory <a href="sqlj245.html#IDX1197">(1197)</a>
</li>
</ul>
</li>
<li>IS NOT NULL boolean operator <a href="sqlj148.html#IDX1043">(1043)</a>
</li>
<li>IS NULL boolean operator <a href="sqlj148.html#IDX1042">(1042)</a>
</li>
<li>ISOLATION <a href="sqlj30.html#IDX821">(821)</a>
</li>
<li>Isolation levels <ul>
<li>setting via JDBC <a href="sqlj183.html#IDX1096">(1096)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_4A">J</a></strong>
<ul>
<li>J2EE <a href="sqlj255.html#IDX1206">(1206)</a>
</li>
<li>Java identifiers <ul>
<li>case sensitivity of within SQL <a href="sqlj08.html#IDX725">(725)</a>
</li>
</ul>
</li>
<li>java.sql.Blob <a href="sqlj208.html#IDX1133">(1133)</a>
</li>
<li>java.sql.CallableStatement <a href="sqlj198.html#IDX1112">(1112)</a> 
<ul>
<li>and INOUT parameters <a href="sqlj200.html#IDX1114">(1114)</a>
</li>
<li>and OUT parameters <a href="sqlj199.html#IDX1113">(1113)</a>
</li>
</ul>
</li>
<li>java.sql.Clob <a href="sqlj208.html#IDX1134">(1134)</a>
</li>
<li>java.sql.Connection <a href="sqlj182.html#IDX1091">(1091)</a>
</li>
<li>java.sql.Connection.isReadOnly <a href="sqlj185.html#IDX1098">(1098)</a>
</li>
<li>java.sql.Connection.setReadOnly <a href="sqlj184.html#IDX1097">(1097)</a>
</li>
<li>java.sql.Connection.setTransactionIsolation <a href="sqlj183.html#IDX1095">(1095)</a>
</li>
<li>java.sql.DatabaseMetaData <a href="sqlj187.html#IDX1099">(1099)</a>
</li>
<li>java.sql.Driver <a href="sqlj174.html#IDX1078">(1078)</a>
</li>
<li>java.sql.Driver.getPropertyInfo <a href="sqlj181.html#IDX1090">(1090)</a>
</li>
<li>java.sql.DriverManager.getConnection <a href="sqlj176.html#IDX1082">(1082)</a>
</li>
<li>java.sql.ParameterMetaData <a href="sqlj221.html#IDX1145">(1145)</a>
</li>
<li>java.sql.PreparedStatement <a href="sqlj196.html#IDX1103">(1103)</a>
</li>
<li>java.sql.ResultSet <a href="sqlj201.html#IDX1115">(1115)</a>
</li>
<li>java.sql.ResultSetMetaData <a href="sqlj203.html#IDX1122">(1122)</a>
</li>
<li>java.sql.Savepoint <a href="sqlj223.html#IDX1146">(1146)</a>
</li>
<li>java.sql.SQLException <a href="sqlj205.html#IDX1123">(1123)</a>
</li>
<li>java.sql.SQLWarning <a href="sqlj206.html#IDX1125">(1125)</a>
</li>
<li>java.sql.Statement <a href="sqlj193.html#IDX1101">(1101)</a>
</li>
<li>java.sql.Types <ul>
<li>mapped to SQL types <a href="sqlj207.html#IDX1126">(1126)</a>
</li>
</ul>
</li>
<li>java.transaction.xa package <a href="sqlj255.html#IDX1216">(1216)</a>
</li>
<li>JavaIdentifiers <ul>
<li>definition <a href="sqlj09.html#IDX736">(736)</a>
</li>
</ul>
</li>
<li>javax.sql.ConnectionPoolDataSource <a href="sqlj255.html#IDX1211">(1211)</a>, <a href="sqlj259.html#IDX1225">(1225)</a>
</li>
<li>javax.sql.DataSource <a href="sqlj255.html#IDX1209">(1209)</a>, <a href="sqlj259.html#IDX1223">(1223)</a>
</li>
<li>javax.sql package <a href="sqlj259.html#IDX1221">(1221)</a>
</li>
<li>javax.sql.PooledConnection <a href="sqlj255.html#IDX1212">(1212)</a>, <a href="sqlj259.html#IDX1226">(1226)</a>
</li>
<li>javax.sql.XAConnection <a href="sqlj259.html#IDX1228">(1228)</a>
</li>
<li>javax.sql.XADataSource <a href="sqlj259.html#IDX1229">(1229)</a>
</li>
<li>javax.sql.XAxxx interfaces <a href="sqlj255.html#IDX1215">(1215)</a>
</li>
<li>javax.transaction.xa.XAException <a href="sqlj257.html#IDX1220">(1220)</a>
</li>
<li>javax.transaction.xa.XAResource <a href="sqlj257.html#IDX1218">(1218)</a>
</li>
<li>javax.transaction.xa.Xid <a href="sqlj257.html#IDX1219">(1219)</a>
</li>
<li>JDBC 2.0 <ul>
<li>standard extensions <a href="sqlj259.html#IDX1222">(1222)</a>
</li>
</ul>
</li>
<li>JDBC 3.0 <ul>
<li>Derby's support for <a href="sqlj218.html#IDX1143">(1143)</a>
</li>
</ul>
</li>
<li>JDBC API <ul>
<li>Derby implementation of <a href="sqlj172.html#IDX1076">(1076)</a>
</li>
</ul>
</li>
<li>JDBC driver <ul>
<li>loading <a href="sqlj174.html#IDX1079">(1079)</a>, <a href="sqlj175.html#IDX1080">(1080)</a>
</li>
</ul>
</li>
<li>jdbc.drivers system property <ul>
<li>using to load driver <a href="sqlj175.html#IDX1081">(1081)</a>
</li>
</ul>
</li>
<li>JDBC escape syntax <a href="sqlj230.html#IDX1153">(1153)</a>
</li>
<li>JDBC types <ul>
<li>mapped to SQL types <a href="sqlj207.html#IDX1127">(1127)</a>
</li>
</ul>
</li>
<li>JNDI <a href="sqlj255.html#IDX1208">(1208)</a>
</li>
<li>JOIN operation <a href="sqlj41.html#IDX867">(867)</a>
</li>
<li>JTA API <a href="sqlj257.html#IDX1217">(1217)</a>
</li>
</ul>
<strong><a href="#IDX0_4B">K</a></strong>
<ul>
<li>Keywords <a href="sqlj150.html#IDX1056">(1056)</a> 
<ul>
<li>case insensitivity of <a href="sqlj08.html#IDX724">(724)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_4C">L</a></strong>
<ul>
<li>LCASE or LOWER (function) <a href="sqlj85.html#IDX931">(931)</a>
</li>
<li>LEFT OUTER JOIN expression <a href="sqlj42.html#IDX869">(869)</a>
</li>
<li>LENGTH function <a href="sqlj64.html#IDX908">(908)</a>, <a href="sqlj146.html#IDX1026">(1026)</a>
</li>
<li>LIKE <ul>
<li>escape character for <a href="sqlj148.html#IDX1045">(1045)</a>
</li>
</ul>
</li>
<li>LIKE boolean operator <a href="sqlj148.html#IDX1044">(1044)</a>
</li>
<li>Limitations <a href="sqlj267.html#IDX1239">(1239)</a> 
<ul>
<li>Database Manager <a href="sqlj272.html#IDX1250">(1250)</a>
</li>
<li>DATE, TIME, and TIMESTAMP <a href="sqlj271.html#IDX1246">(1246)</a>
</li>
<li>Identifier length <a href="sqlj268.html#IDX1240">(1240)</a>
</li>
<li>Numeric <a href="sqlj269.html#IDX1242">(1242)</a>
</li>
<li>String <a href="sqlj270.html#IDX1244">(1244)</a>
</li>
</ul>
</li>
<li>locate (JDBC scalar function) <a href="sqlj234.html#IDX1166">(1166)</a>
</li>
<li>LOCATE function <a href="sqlj84.html#IDX930">(930)</a>
</li>
<li>Lock escalation <ul>
<li>by user <a href="sqlj43.html#IDX872">(872)</a>
</li>
</ul>
</li>
<li>LOCK TABLE statement <a href="sqlj43.html#IDX870">(870)</a>
</li>
<li>logDevice=logDirectoryPath (database connection URL attribute) <a href="sqlj246.html#IDX1198">(1198)</a>
</li>
<li>LONG VARCHAR data type <a href="sqlj137.html#IDX1005">(1005)</a>
</li>
<li>LONG VARCHAR FOR BIT DATA type <a href="sqlj138.html#IDX1006">(1006)</a>
</li>
<li>LONGVARBINARY <a href="sqlj207.html#IDX1130">(1130)</a>
</li>
<li>LONGVARCHAR <a href="sqlj207.html#IDX1131">(1131)</a>
</li>
<li>LTRIM (function) <a href="sqlj86.html#IDX932">(932)</a>
</li>
</ul>
<strong><a href="#IDX0_4D">M</a></strong>
<ul>
<li>Mapping <ul>
<li>of SQL types to java.sql.Types <a href="sqlj207.html#IDX1132">(1132)</a>
</li>
</ul>
</li>
<li>MAX aggregate function <a href="sqlj87.html#IDX933">(933)</a>
</li>
<li>MIN aggregate function <a href="sqlj88.html#IDX934">(934)</a>
</li>
<li>MINUTE function <a href="sqlj89.html#IDX935">(935)</a>
</li>
<li>mod (JDBC scalar function) <a href="sqlj234.html#IDX1168">(1168)</a>
</li>
<li>MOD function <a href="sqlj90.html#IDX936">(936)</a>
</li>
<li>MONTH function <a href="sqlj91.html#IDX937">(937)</a>
</li>
</ul>
<strong><a href="#IDX0_4E">N</a></strong>
<ul>
<li>new-table-Name identifier <a href="sqlj14.html#IDX741">(741)</a>
</li>
<li>NOT boolean operator <a href="sqlj148.html#IDX1040">(1040)</a>
</li>
<li>NULL <ul>
<li>not a data type <a href="sqlj123.html#IDX986">(986)</a>
</li>
</ul>
</li>
<li>NULL expression <a href="sqlj146.html#IDX1018">(1018)</a>
</li>
<li>NULLIF expression <a href="sqlj66.html#IDX910">(910)</a>
</li>
<li>NUMERIC data type <a href="sqlj139.html#IDX1007">(1007)</a>
</li>
<li>Numeric data types <a href="sqlj124.html#IDX988">(988)</a> 
<ul>
<li>implicit conversion <a href="sqlj124.html#IDX990">(990)</a>
</li>
<li>promotion of in expressions <a href="sqlj124.html#IDX989">(989)</a>
</li>
</ul>
</li>
<li>Numeric expressions <a href="sqlj146.html#IDX1024">(1024)</a>
</li>
<li>Numeric limitations <a href="sqlj269.html#IDX1243">(1243)</a>
</li>
</ul>
<strong><a href="#IDX0_4F">O</a></strong>
<ul>
<li>oj (JDBC escape keyword) <a href="sqlj235.html#IDX1169">(1169)</a>
</li>
<li>ON clause <ul>
<li>part of INNER JOIN expression <a href="sqlj39.html#IDX864">(864)</a>
</li>
</ul>
</li>
<li>OR boolean operator <a href="sqlj148.html#IDX1039">(1039)</a>
</li>
<li>ORDER BY clause <a href="sqlj44.html#IDX873">(873)</a> 
<ul>
<li>affecting cursors <a href="sqlj44.html#IDX876">(876)</a>
</li>
<li>needed to guarantee order of results <a href="sqlj49.html#IDX886">(886)</a>
</li>
</ul>
</li>
<li>Outer joins <a href="sqlj41.html#IDX868">(868)</a> 
<ul>
<li>JDBC escape syntax for <a href="sqlj235.html#IDX1171">(1171)</a>
</li>
</ul>
</li>
</ul>
<strong><a name="IDX1_50"></a>P<a href="#IDX0_50">P</a></strong>
<ul>
<li>password=userPassword (database connection URL attribute) <a href="sqlj247.html#IDX1199">(1199)</a>
</li>
<li>Precision <ul>
<li>of decimal arithmetic expressions <a href="sqlj124.html#IDX992">(992)</a>
</li>
</ul>
</li>
<li>Prepared statements <ul>
<li>tracking of dependencies <a href="sqlj25.html#IDX752">(752)</a>
</li>
<li>use of dynamic parameters in <a href="sqlj149.html#IDX1052">(1052)</a>
</li>
</ul>
</li>
<li>Primary key constraints <a href="sqlj32.html#IDX839">(839)</a>
</li>
<li>Primary keys <ul>
<li>adding <a href="sqlj32.html#IDX833">(833)</a>, <a href="sqlj32.html#IDX837">(837)</a>
</li>
<li>creating <a href="sqlj32.html#IDX832">(832)</a>, <a href="sqlj32.html#IDX836">(836)</a>
</li>
</ul>
</li>
<li>Procedure <ul>
<li>Create <a href="sqlj27.html#IDX783">(783)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_51">Q</a></strong>
<ul>
<li>Quantified comparison boolean operator <a href="sqlj148.html#IDX1049">(1049)</a>
</li>
</ul>
<strong><a href="#IDX0_52">R</a></strong>
<ul>
<li>Read-write VTIs <ul>
<li>and DELETES <a href="sqlj34.html#IDX855">(855)</a>
</li>
<li>and INSERTs <a href="sqlj40.html#IDX866">(866)</a>
</li>
</ul>
</li>
<li>REAL data type <a href="sqlj140.html#IDX1008">(1008)</a>
</li>
<li>Referential actions <a href="sqlj32.html#IDX850">(850)</a>
</li>
<li>Referential integrity <ul>
<li>via foreign keys <a href="sqlj32.html#IDX842">(842)</a>
</li>
</ul>
</li>
<li>RENAME INDEX statement <a href="sqlj29.html#IDX816">(816)</a>
</li>
<li>RENAME TABLE statement <a href="sqlj29.html#IDX817">(817)</a>
</li>
<li>Reserved words <a href="sqlj150.html#IDX1055">(1055)</a>
</li>
<li>Resource manager <ul>
<li>Derby as in J2EE system <a href="sqlj255.html#IDX1207">(1207)</a>
</li>
</ul>
</li>
<li>restoreFrom=Path (database connection URL attribute) <a href="sqlj250.html#IDX1202">(1202)</a>
</li>
<li>ResultSets <ul>
<li>errors in statement affecting creation of <a href="sqlj194.html#IDX1102">(1102)</a>
</li>
</ul>
</li>
<li>RIGHT OUTER JOIN expression <a href="sqlj46.html#IDX879">(879)</a>
</li>
<li>rollforwardRecovery=Path (database connection URL attribute) <a href="sqlj248.html#IDX1200">(1200)</a>
</li>
<li>RTRIM (function) <a href="sqlj92.html#IDX938">(938)</a>
</li>
</ul>
<strong><a href="#IDX0_53">S</a></strong>
<ul>
<li>Savepoints <ul>
<li>methods <a href="sqlj227.html#IDX1151">(1151)</a>
</li>
<li>releasing <a href="sqlj225.html#IDX1150">(1150)</a>
</li>
<li>setting and rollong back <a href="sqlj223.html#IDX1148">(1148)</a>
</li>
<li>setting and rollong back to <a href="sqlj224.html#IDX1149">(1149)</a>
</li>
</ul>
</li>
<li>Savepoints (JDBC) <a href="sqlj219.html#IDX1144">(1144)</a>, <a href="sqlj223.html#IDX1147">(1147)</a>
</li>
<li>Scalar subquery expression <a href="sqlj146.html#IDX1021">(1021)</a>
</li>
<li>ScalarSubquery <a href="sqlj47.html#IDX880">(880)</a>
</li>
<li>Scale <ul>
<li>for decimal arithmetic <a href="sqlj124.html#IDX991">(991)</a>
</li>
<li>of decimal arithmetic expressions <a href="sqlj124.html#IDX993">(993)</a>
</li>
</ul>
</li>
<li>schema-Name identifier <a href="sqlj12.html#IDX739">(739)</a>
</li>
<li>Schemas <ul>
<li>APP as default <a href="sqlj176.html#IDX1083">(1083)</a>
</li>
<li>changing default for session <a href="sqlj30.html#IDX819">(819)</a>, <a href="sqlj72.html#IDX919">(919)</a>
</li>
<li>creating <a href="sqlj27.html#IDX785">(785)</a>
</li>
<li>dropping <a href="sqlj28.html#IDX809">(809)</a>
</li>
</ul>
</li>
<li>Scroll insensitive cursors (JDBC) <a href="sqlj210.html#IDX1137">(1137)</a>
</li>
<li>Scrolling insensitive cursors <a href="sqlj210.html#IDX1138">(1138)</a>
</li>
<li>SECOND function <a href="sqlj93.html#IDX939">(939)</a>
</li>
<li>Select expression <a href="sqlj48.html#IDX882">(882)</a>
</li>
<li>SELECT statement <a href="sqlj49.html#IDX885">(885)</a>
</li>
<li>SESSION_USER (function) <a href="sqlj94.html#IDX940">(940)</a>
</li>
<li>Set functions <a href="sqlj58.html#IDX895">(895)</a>
</li>
<li>SET ISOLATION statement <a href="sqlj30.html#IDX820">(820)</a>
</li>
<li>SET SCHEMA statement <a href="sqlj30.html#IDX818">(818)</a>, <a href="sqlj72.html#IDX918">(918)</a>
</li>
<li>setAsciiStream <a href="sqlj197.html#IDX1108">(1108)</a>
</li>
<li>setBinaryStream <a href="sqlj197.html#IDX1106">(1106)</a>, <a href="sqlj197.html#IDX1107">(1107)</a>
</li>
<li>setUnicodeStream <a href="sqlj197.html#IDX1109">(1109)</a>
</li>
<li>setXXXStream requests <a href="sqlj197.html#IDX1104">(1104)</a>
</li>
<li>shutdown=true (database connection URL attribute) <a href="sqlj251.html#IDX1203">(1203)</a>
</li>
<li>Simple-column-Name identifier <a href="sqlj18.html#IDX745">(745)</a>
</li>
<li>SMALL INTEGER data type <a href="sqlj141.html#IDX1009">(1009)</a>
</li>
<li>SMALLINT function <a href="sqlj95.html#IDX941">(941)</a>
</li>
<li>Special characters <ul>
<li>escaping in SQL statements <a href="sqlj08.html#IDX721">(721)</a>
</li>
</ul>
</li>
<li>SQL-92 <ul>
<li>features not supported by Derby <a href="sqlj151.html#IDX1058">(1058)</a>
</li>
<li>features supported by Derby <a href="sqlj151.html#IDX1057">(1057)</a>
</li>
</ul>
</li>
<li>SQL-92 data types <ul>
<li>supported by Derby <a href="sqlj123.html#IDX987">(987)</a>
</li>
</ul>
</li>
<li>SQL identifiers <ul>
<li>definition <a href="sqlj09.html#IDX732">(732)</a>
</li>
</ul>
</li>
<li>SQL92Identifiers <ul>
<li>definition <a href="sqlj09.html#IDX735">(735)</a>
</li>
<li>rules for <a href="sqlj10.html#IDX737">(737)</a>
</li>
</ul>
</li>
<li>SQLExceptions <ul>
<li>chaining <a href="sqlj169.html#IDX1075">(1075)</a>, <a href="sqlj205.html#IDX1124">(1124)</a>
</li>
</ul>
</li>
<li>SQLState values <a href="sqlj169.html#IDX1074">(1074)</a>
</li>
<li>SQLState XJZZZ <ul>
<li>meaning of <a href="sqlj172.html#IDX1077">(1077)</a>
</li>
</ul>
</li>
<li>SQRT (function) <a href="sqlj96.html#IDX942">(942)</a>
</li>
<li>sqrt (JDBC scalar function) <a href="sqlj234.html#IDX1164">(1164)</a>
</li>
<li>Statements <ul>
<li>CALL (PROCEDURE) <a href="sqlj31.html#IDX823">(823)</a>
</li>
<li>DROP FUNCTION <a href="sqlj28.html#IDX804">(804)</a>
</li>
<li>DROP PROCEDURE <a href="sqlj28.html#IDX807">(807)</a>
</li>
</ul>
</li>
<li>Storage properties <ul>
<li>for indexes backing constraints <a href="sqlj32.html#IDX845">(845)</a>
</li>
</ul>
</li>
<li>Stream <a href="sqlj197.html#IDX1111">(1111)</a>
</li>
<li>Streaming columns <ul>
<li>as IN parameters to prepared statement <a href="sqlj197.html#IDX1105">(1105)</a>
</li>
<li>retrieving from ResultSets using getXXXStream methods <a href="sqlj202.html#IDX1118">(1118)</a>
</li>
</ul>
</li>
<li>String expressions <ul>
<li>with wildcards <a href="sqlj146.html#IDX1028">(1028)</a>
</li>
</ul>
</li>
<li>String limitations <a href="sqlj270.html#IDX1245">(1245)</a>
</li>
<li>Strings <ul>
<li>delimited by single quotation marks within SQL statements <a href="sqlj08.html#IDX720">(720)</a>
</li>
</ul>
</li>
<li>SUBSTR (function) <a href="sqlj97.html#IDX943">(943)</a>
</li>
<li>substring (JDBC scalar function) <a href="sqlj234.html#IDX1167">(1167)</a>
</li>
<li>Subsubprotocol <ul>
<li>part of database connection URL syntax <a href="sqlj178.html#IDX1086">(1086)</a>
</li>
</ul>
</li>
<li>SUM aggregate function <a href="sqlj98.html#IDX944">(944)</a>
</li>
<li>SYSALIASES system table <a href="sqlj153.html#IDX1059">(1059)</a>
</li>
<li>SYSCHECKS system table <a href="sqlj154.html#IDX1060">(1060)</a>
</li>
<li>SYSCOLUMNS system table <a href="sqlj155.html#IDX1061">(1061)</a>
</li>
<li>SYSCONGLOMERATES system table <a href="sqlj156.html#IDX1062">(1062)</a>
</li>
<li>SYSCONSTRAINTS system table <a href="sqlj157.html#IDX1063">(1063)</a>
</li>
<li>SYSCS_UTIL.SYSCS_BACKUP_DATABASE system procedure <a href="sqlj117.html#IDX973">(973)</a>
</li>
<li>SYSCS_UTIL.SYSCS_CHECK_TABLE function <a href="sqlj106.html#IDX951">(951)</a>
</li>
<li>SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE system procedure <a href="sqlj116.html#IDX971">(971)</a>
</li>
<li>SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure <a href="sqlj110.html#IDX959">(959)</a>
</li>
<li>SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure <a href="sqlj119.html#IDX979">(979)</a>
</li>
<li>SYSCS_UTIL.SYSCS_EXPORT_TABLE system procedure <a href="sqlj118.html#IDX976">(976)</a>
</li>
<li>SYSCS_UTIL.SYSCS_FREEZE_DATABASE system procedure <a href="sqlj114.html#IDX967">(967)</a>
</li>
<li>SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY function <a href="sqlj108.html#IDX955">(955)</a>
</li>
<li>SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS function <a href="sqlj107.html#IDX953">(953)</a>
</li>
<li>SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure <a href="sqlj121.html#IDX985">(985)</a>
</li>
<li>SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure <a href="sqlj120.html#IDX982">(982)</a>
</li>
<li>SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY system procedure <a href="sqlj113.html#IDX965">(965)</a>
</li>
<li>SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS system procedure <a href="sqlj111.html#IDX961">(961)</a>
</li>
<li>SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING system procedure <a href="sqlj112.html#IDX963">(963)</a>
</li>
<li>SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE system procedure <a href="sqlj115.html#IDX969">(969)</a>
</li>
<li>SYSDEPENDS system table <a href="sqlj158.html#IDX1064">(1064)</a>
</li>
<li>SYSFILES system table <a href="sqlj159.html#IDX1065">(1065)</a>
</li>
<li>SYSFOREIGNKEYS system table <a href="sqlj160.html#IDX1066">(1066)</a>
</li>
<li>SYSKEYS system table <a href="sqlj161.html#IDX1067">(1067)</a>
</li>
<li>SYSSCHEMAS system table <a href="sqlj162.html#IDX1068">(1068)</a>
</li>
<li>SYSSTATEMENTS system table <a href="sqlj164.html#IDX1070">(1070)</a>
</li>
<li>SYSSTATISTICS system table <a href="sqlj163.html#IDX1069">(1069)</a>
</li>
<li>SYSTABLES system table <a href="sqlj165.html#IDX1071">(1071)</a>
</li>
<li>system functions <ul>
<li>SYSCS_UTIL.SYSCS_CHECK_TABLE <a href="sqlj106.html#IDX952">(952)</a>
</li>
<li>SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY <a href="sqlj108.html#IDX956">(956)</a>
</li>
<li>SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS <a href="sqlj107.html#IDX954">(954)</a>
</li>
</ul>
</li>
<li>System procedures <ul>
<li>SYSCS_UTIL.SYSCS_BACKUP_DATABASE <a href="sqlj117.html#IDX972">(972)</a>
</li>
<li>SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE <a href="sqlj116.html#IDX970">(970)</a>
</li>
<li>SYSCS_UTIL.SYSCS_COMPRESS_TABLE <a href="sqlj110.html#IDX958">(958)</a>
</li>
<li>SYSCS_UTIL.SYSCS_EXPORT_QUERY <a href="sqlj119.html#IDX977">(977)</a>
</li>
<li>SYSCS_UTIL.SYSCS_EXPORT_TABLE <a href="sqlj118.html#IDX974">(974)</a>
</li>
<li>SYSCS_UTIL.SYSCS_FREEZE_DATABASE <a href="sqlj114.html#IDX966">(966)</a>
</li>
<li>SYSCS_UTIL.SYSCS_IMPORT_DATA <a href="sqlj121.html#IDX983">(983)</a>
</li>
<li>SYSCS_UTIL.SYSCS_IMPORT_TABLE <a href="sqlj120.html#IDX980">(980)</a>
</li>
<li>SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY <a href="sqlj113.html#IDX964">(964)</a>
</li>
<li>SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS <a href="sqlj111.html#IDX960">(960)</a>
</li>
<li>SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING <a href="sqlj112.html#IDX962">(962)</a>
</li>
<li>SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE <a href="sqlj115.html#IDX968">(968)</a>
</li>
</ul>
</li>
<li>SYSTRIGGERS system table <a href="sqlj166.html#IDX1072">(1072)</a>
</li>
<li>SYSVIEWS system table <a href="sqlj167.html#IDX1073">(1073)</a>
</li>
</ul>
<strong><a href="#IDX0_54">T</a></strong>
<ul>
<li>t (JDBC escape keyword) <a href="sqlj236.html#IDX1172">(1172)</a>
</li>
<li>Table constraints <ul>
<li>used in CREATE TABLE statement <a href="sqlj32.html#IDX834">(834)</a>
</li>
</ul>
</li>
<li>Table-level constraints <a href="sqlj32.html#IDX828">(828)</a>
</li>
<li>table-Name identifier <a href="sqlj13.html#IDX740">(740)</a>
</li>
<li>Table subquery expression <a href="sqlj146.html#IDX1022">(1022)</a>
</li>
<li>TableExpression <a href="sqlj50.html#IDX887">(887)</a>
</li>
<li>Tables <ul>
<li>altering <a href="sqlj26.html#IDX755">(755)</a>
</li>
<li>changing lock granularity for <a href="sqlj26.html#IDX773">(773)</a>
</li>
<li>compressing <a href="sqlj26.html#IDX756">(756)</a>
</li>
<li>dropping <a href="sqlj28.html#IDX811">(811)</a>
</li>
<li>locking <a href="sqlj43.html#IDX871">(871)</a>
</li>
<li>specifying page size for <a href="sqlj32.html#IDX847">(847)</a>
</li>
<li>specifying properties for <a href="sqlj32.html#IDX848">(848)</a>
</li>
<li>Temporary <a href="sqlj33.html#IDX853">(853)</a>
</li>
</ul>
</li>
<li>TableSubquery <a href="sqlj51.html#IDX888">(888)</a>
</li>
<li>Territories <ul>
<li>supported <a href="sqlj266.html#IDX1238">(1238)</a>
</li>
</ul>
</li>
<li>territory <ul>
<li>database <a href="sqlj245.html#IDX1196">(1196)</a>
</li>
</ul>
</li>
<li>territory=ll_CC (database connection URL attribute) <a href="sqlj245.html#IDX1194">(1194)</a>
</li>
<li>TIME data type <a href="sqlj142.html#IDX1010">(1010)</a>
</li>
<li>Time formats <ul>
<li>JDBC escape syntax for <a href="sqlj236.html#IDX1174">(1174)</a>
</li>
</ul>
</li>
<li>TIME function <a href="sqlj99.html#IDX945">(945)</a>
</li>
<li>TIME limitations <a href="sqlj271.html#IDX1248">(1248)</a>
</li>
<li>TIMESTAMP data type <a href="sqlj143.html#IDX1011">(1011)</a>
</li>
<li>Timestamp formats <ul>
<li>JDBC escape syntax for <a href="sqlj237.html#IDX1177">(1177)</a>
</li>
</ul>
</li>
<li>TIMESTAMP function <a href="sqlj100.html#IDX946">(946)</a>
</li>
<li>TIMESTAMP limitations <a href="sqlj271.html#IDX1249">(1249)</a>
</li>
<li>TriggerName identifier <a href="sqlj22.html#IDX749">(749)</a>
</li>
<li>Triggers <ul>
<li>and database events <a href="sqlj27.html#IDX794">(794)</a>
</li>
<li>and recursion <a href="sqlj27.html#IDX800">(800)</a>
</li>
<li>and the referencing clause <a href="sqlj27.html#IDX795">(795)</a>
</li>
<li>creating <a href="sqlj27.html#IDX792">(792)</a>
</li>
<li>defining when they fire <a href="sqlj27.html#IDX793">(793)</a>
</li>
<li>dropping <a href="sqlj28.html#IDX813">(813)</a>
</li>
<li>order of execution <a href="sqlj27.html#IDX799">(799)</a>
</li>
<li>referencing old and new values <a href="sqlj27.html#IDX796">(796)</a>
</li>
<li>statement versus row triggers <a href="sqlj27.html#IDX797">(797)</a>
</li>
<li>the triggered-SQL-statement <a href="sqlj27.html#IDX798">(798)</a>
</li>
</ul>
</li>
<li>ts (JDBC escape keyword) <a href="sqlj237.html#IDX1175">(1175)</a>
</li>
<li>Type correspondence <ul>
<li>for JDBC and SQL types <a href="sqlj207.html#IDX1128">(1128)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_55">U</a></strong>
<ul>
<li>Unicode <ul>
<li>setUnicodeStream <a href="sqlj197.html#IDX1110">(1110)</a>
</li>
</ul>
</li>
<li>Unicode escapes <ul>
<li>support for in SQL statements <a href="sqlj08.html#IDX719">(719)</a>
</li>
</ul>
</li>
<li>UNION <a href="sqlj45.html#IDX877">(877)</a>
</li>
<li>UNION ALL <a href="sqlj45.html#IDX878">(878)</a>
</li>
<li>Unique constraints <a href="sqlj32.html#IDX840">(840)</a>
</li>
<li>UPDATE statement <a href="sqlj52.html#IDX889">(889)</a>
</li>
<li>UPPER function <a href="sqlj101.html#IDX947">(947)</a>
</li>
<li>USER function <a href="sqlj102.html#IDX948">(948)</a>
</li>
<li>user=userName (database connection URL attribute) <a href="sqlj252.html#IDX1204">(1204)</a>
</li>
</ul>
<strong><a href="#IDX0_56">V</a></strong>
<ul>
<li>VALUES expression <a href="sqlj53.html#IDX890">(890)</a>
</li>
<li>VARCHAR data type <a href="sqlj144.html#IDX1012">(1012)</a>
</li>
<li>VARCHAR FOR BIT DATA type <a href="sqlj145.html#IDX1013">(1013)</a>
</li>
<li>VARCHAR function <a href="sqlj103.html#IDX949">(949)</a>
</li>
<li>view-Name identifier <a href="sqlj15.html#IDX742">(742)</a>
</li>
<li>Views <ul>
<li>creating <a href="sqlj27.html#IDX802">(802)</a>
</li>
<li>dropping <a href="sqlj28.html#IDX815">(815)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_57">W</a></strong>
<ul>
<li>WHERE clause <a href="sqlj54.html#IDX891">(891)</a> 
<ul>
<li>SQL extensions to <a href="sqlj54.html#IDX892">(892)</a>
</li>
</ul>
</li>
<li>WHERE CURRENT OF clause <a href="sqlj55.html#IDX893">(893)</a>
</li>
<li>Wildcards in SQL <a href="sqlj08.html#IDX729">(729)</a>
</li>
</ul>
<strong><a href="#IDX0_58">X</a></strong>
<ul>
<li>XA <a href="sqlj255.html#IDX1213">(1213)</a>
</li>
</ul>
<strong><a href="#IDX0_59">Y</a></strong>
<ul>
<li>YEAR function <a href="sqlj104.html#IDX950">(950)</a>
</li>
</ul>
<hr>
<a href="sqlj274.html">Previous Page</a>
<br>
<a href="sqlj02.html#ToC">Table of Contents</a>
<br>
<a href="#HDRINDEX_START">Index</a>
</div>
<div class="attribution"></div>
</div>
</td><td width="10"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<!--================= end Content==================-->
</table>
</td>
</tr>
</table>
<!--================= end Menu, NavBar, Content ==================-->
<!--================= start Footer ==================-->
<table summary="footer" cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td colspan="2" height="1" bgcolor="#4C6C8F"><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"><a href="../../skin/images/label.gif"></a><a href="../../skin/images/page.gif"></a><a href="../../skin/images/chapter.gif"></a><a href="../../skin/images/chapter_open.gif"></a><a href="../../skin/images/current.gif"></a><a href="/favicon.ico"></a></td>
</tr>
<tr>
<td colspan="2" bgcolor="#CFDCED" class="copyright" align="center"><font size="2" face="Arial, Helvetica, Sans-Serif">Copyright &copy;
          2004&nbsp;Apache Software Foundation All rights reserved.<script type="text/javascript" language="JavaScript"><!--
              document.write(" - "+"Last Published: " + document.lastModified);
            //  --></script></font></td>
</tr>
<tr>
<td colspan="2" align="left" bgcolor="#CFDCED" class="logos"></td>
</tr>
</table>
<!--================= end Footer ==================-->
</body>
</html>
